import { Sequelize } from 'sequelize';
import { dbConnectMySQL } from '../utilities';

// Создание sql-таблицы balances
export const Spread_SQL = dbConnectMySQL.define('spread', {
	id: {
		type: Sequelize.INTEGER,
		autoIncrement: true,
		primaryKey: true,
		allowNull: false,
	},
	baseAsset: { type: Sequelize.STRING, allowNull: false }, // coin
	spotExchangeId: { type: Sequelize.STRING, allowNull: false },
	spotExchange: { type: Sequelize.STRING, allowNull: false },
	buyPrice: { type: Sequelize.STRING, allowNull: false },
	futExchangeId: { type: Sequelize.STRING, allowNull: false },
	futExchange: { type: Sequelize.STRING, allowNull: false },
	sellPrice: { type: Sequelize.STRING, allowNull: false }, 
	spread: { type: Sequelize.STRING, allowNull: false },
	fundRate: { type: Sequelize.STRING, allowNull: false },
});
